﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace DataAccess
{
    public class TruyXuatXemVeDat
    {
        int _soThe;

        public int SoThe
        {
            get { return _soThe; }
            set { _soThe = value; }
        }
        DataTable tableDatVe;

        public DataTable TableDatVe
        {
            get { return tableDatVe; }
            set { tableDatVe = value; }
        }
        public void ThucThi()
        {
            DataProvider dp = new DataProvider();
            dp.KetNoi();
            string sql = "select DATVE.* from DatVe,CHITIETDATVE where DATVE.MaDatVe = CHITIETDATVE.MaDatVe and CHITIETDATVE.SoHoiVien= "+SoThe+"";
            TableDatVe = dp.ExcuteQuery(sql);
        }
    }
}
